package cn.leestudio.springboot.dao.leestudio;

import cn.leestudio.springboot.model.User;
import org.apache.ibatis.annotations.*;
import org.apache.ibatis.type.JdbcType;

import java.util.List;

/**
 * Created by Administrator on 2018/3/8.
 */
public interface UserMapperExt extends UserMapper {
    @Select({
            "select * from users order by id desc"
    })
//    @Results({
//            @Result(column="id", property="id", jdbcType= JdbcType.INTEGER, id=true),
//            @Result(column="firstName", property="firstname", jdbcType=JdbcType.VARCHAR),
//            @Result(column="lastName", property="lastname", jdbcType=JdbcType.VARCHAR),
//            @Result(column="sex", property="sex", jdbcType=JdbcType.INTEGER),
//            @Result(column="createdAt", property="createdat", jdbcType=JdbcType.TIMESTAMP),
//            @Result(column="updatedAt", property="updatedat", jdbcType=JdbcType.TIMESTAMP)
//    })
    List<User> selectByPage();
}
